package io.chenglicun.modules.clc.controller.dataset;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import io.chenglicun.common.annotation.LogOperation;
import io.chenglicun.common.constant.Constant;
import io.chenglicun.common.page.PageData;
import io.chenglicun.common.utils.ExcelUtils;
import io.chenglicun.common.utils.Result;
import io.chenglicun.common.validator.AssertUtils;
import io.chenglicun.common.validator.ValidatorUtils;
import io.chenglicun.common.validator.group.AddGroup;
import io.chenglicun.common.validator.group.DefaultGroup;
import io.chenglicun.common.validator.group.UpdateGroup;
import io.chenglicun.modules.clc.dao.dataset.ClcDataContentBakDao;
import io.chenglicun.modules.clc.dao.dataset.ClcDataContentDao;
import io.chenglicun.modules.clc.dto.dataset.ClcDataContentBakDTO;
import io.chenglicun.modules.clc.dto.dataset.ClcDataContentDTO;
import io.chenglicun.modules.clc.entity.dataset.ClcDataContentBakEntity;
import io.chenglicun.modules.clc.entity.dataset.ClcDataContentEntity;
import io.chenglicun.modules.clc.excel.dataset.ClcDataContentBakExcel;
import io.chenglicun.modules.clc.service.dataset.ClcDataContentBakService;
import io.chenglicun.modules.security.user.SecurityUser;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
import io.swagger.annotations.ApiOperation;
import org.apache.shiro.authz.annotation.RequiresPermissions;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import springfox.documentation.annotations.ApiIgnore;

import javax.servlet.http.HttpServletResponse;
import java.util.Date;
import java.util.List;
import java.util.Map;


/**
 * 数据内容删除备份
 *
 * @author HFHQ 137664951@qq.com
 * @since 1.0 2024-04-15
 */
@RestController
@RequestMapping("clc/clcdatacontentbak")
@Api(tags = "数据内容删除备份")
public class ClcDataContentBakController {
    @Autowired
    private ClcDataContentBakService clcDataContentBakService;
    @Autowired
    private ClcDataContentBakDao bakDao;
    @Autowired
    private ClcDataContentDao contentDao;

    @GetMapping("page")
    @ApiOperation("分页")
    @ApiImplicitParams({
            @ApiImplicitParam(name = Constant.PAGE, value = "当前页码，从1开始", paramType = "query", required = true, dataType = "int"),
            @ApiImplicitParam(name = Constant.LIMIT, value = "每页显示记录数", paramType = "query", required = true, dataType = "int"),
            @ApiImplicitParam(name = Constant.ORDER_FIELD, value = "排序字段", paramType = "query", dataType = "String"),
            @ApiImplicitParam(name = Constant.ORDER, value = "排序方式，可选值(asc、desc)", paramType = "query", dataType = "String")
    })
    @RequiresPermissions("clc:clcdatacontentbak:page")
    public Result<PageData<ClcDataContentBakDTO>> page(@ApiIgnore @RequestParam Map<String, Object> params) {
        PageData<ClcDataContentBakDTO> page = clcDataContentBakService.getPage(params);

        return new Result<PageData<ClcDataContentBakDTO>>().ok(page);
    }

    @GetMapping("{id}")
    @ApiOperation("信息")
    @RequiresPermissions("clc:clcdatacontentbak:info")
    public Result<ClcDataContentBakDTO> get(@PathVariable("id") Long id) {
        ClcDataContentBakDTO data = clcDataContentBakService.get(id);

        return new Result<ClcDataContentBakDTO>().ok(data);
    }

    @PostMapping
    @ApiOperation("保存")
    @LogOperation("保存")
    @RequiresPermissions("clc:clcdatacontentbak:save")
    public Result save(@RequestBody ClcDataContentBakDTO dto) {
        //效验数据
        ValidatorUtils.validateEntity(dto, AddGroup.class, DefaultGroup.class);

        clcDataContentBakService.save(dto);

        return new Result();
    }

    @PutMapping
    @ApiOperation("修改")
    @LogOperation("修改")
    @RequiresPermissions("clc:clcdatacontentbak:update")
    public Result update(@RequestBody ClcDataContentBakDTO dto) {
        //效验数据
        ValidatorUtils.validateEntity(dto, UpdateGroup.class, DefaultGroup.class);

        clcDataContentBakService.update(dto);

        return new Result();
    }

    @DeleteMapping
    @ApiOperation("删除")
    @LogOperation("删除")
    @RequiresPermissions("clc:clcdatacontentbak:delete")
    public Result delete(@RequestBody Long[] ids) {
        //效验数据
        AssertUtils.isArrayEmpty(ids, "id");
        if (ids.length <= 0)
            return new Result();
        List<ClcDataContentBakEntity> clcDataContentEntities = bakDao.selectList(new QueryWrapper<ClcDataContentBakEntity>().lambda().in(ClcDataContentBakEntity::getId, ids));
        for (ClcDataContentBakEntity bak : clcDataContentEntities) {
            ClcDataContentEntity content = new ClcDataContentEntity();
            content.setSetId(bak.getSetId());
            content.setRowNum(bak.getRowNum());
            content.setColumnId(bak.getColumnId());
            content.setValue(bak.getValue());
            content.setCreator(SecurityUser.getUserId());
            contentDao.insert(content);
            bak.setRecoveryName(SecurityUser.getUser().getRealName());
            bak.setRecoveryUserid(SecurityUser.getUserId());
            bak.setRecoveryTime(new Date());
            clcDataContentBakService.updateById(bak);
        }
//        clcDataContentBakService.delete(ids);

        return new Result();
    }

    @GetMapping("export")
    @ApiOperation("导出")
    @LogOperation("导出")
    @RequiresPermissions("clc:clcdatacontentbak:export")
    public void export(@ApiIgnore @RequestParam Map<String, Object> params, HttpServletResponse response) throws Exception {
        List<ClcDataContentBakDTO> list = clcDataContentBakService.list(params);

        ExcelUtils.exportExcelToTarget(response, null, "数据内容删除备份", list, ClcDataContentBakExcel.class);
    }

}